clear all
set more off
cd "/Users/yasenov/Dropbox/mariel_boatlift/jhr_version/jhr_figures"
global folder /Users/yasenov/Dropbox/mariel_boatlift/revision_version/revision_data/

use $folder/aux_march.dta

keep if low_skilled == 1
keep if hisp == 0
keep if age >= 25 & age <= 59
keep if male == 1
keep if labforce == 2
drop if classwly == 10 | classwly == 13 | classwly == 14 
keep if logwage > 0

keep if metarea == 5000 | metarea == 7400 | metarea == 5601 |  metarea == 6840 | metarea == 4481  // this is employment placebo
tab metarea
replace year = year - 1
keep if year > 1977 & year < 1983
gen sample_size = 1 
collapse (sum) sample_size, by(year metarea)
sort metarea year
list 

reshape wide sample, i(year) j(metarea)
rename (sample_size4481 sample_size5000 sample_size5601 sample_size6840 sample_size7400) ///
	(Anaheim_Santa_Ana Miami Nassau_Suffolk Rochester San_Jose)

label var year "Year"
label var Anaheim_Santa_Ana "Anaheim-Santa Ana, CA" 
label var Miami "Miami, FL"
label var Nassau_Suffolk "Nassau-Suffolk, NY"
label var Rochester "Rochester, NY"
label var San_Jose "San Jose ,CA"
	
export excel using "jhr_taba3", replace firstrow(varlabels)
